How to: Set a record-locking method in a multi-user environment.
Solution:
Select 'Options...' from the 'Tools' menu, select the desired radio button from the 'Default Record Locking' group of the 'Advanced' tab, and click 'Apply' or the 'OK'.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Advanced' tab.
3) Do one of the following in the 'Default Record Locking' group:
the Default Record Locking group
a) Select the 'No Locks' radio button to not lock the record being edited by default.
b) Select the 'All Records' radio button to lock all records in the open form or datasheet by default.
c) Select the 'Edited Records' radio button to lock the records currently being edited by default.
4) Do one of the following:
a) Click 'Apply' to apply the new settings and keep the 'Options' dialog box open.
NOTE: Click 'Apply' when there are changes that need to be made to settings on another tab. This avoids having to re-open the 'Options' dialog box.
b) Click 'OK' to apply the new settings and close the 'Options' dialog box.
